package shop;

import common.db.*;
import common.main.*;

public class GoodsReviewWriteBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String id = (String)inputTable.get("id");
		String gno = (String)inputTable.get("gno");
		String name = (String)inputTable.get("name");
		String pass = (String)inputTable.get("pass");
		String content = (String)inputTable.get("content");
		String client = (String)inputTable.get("client");

		content = content.replaceAll("'", "''");

		queryBuffer = new StringBuffer("");
		queryBuffer.append("INSERT INTO GOODS_REVIEW (");
		queryBuffer.append("SEQ, CODE, CONTENT, NAME, PASS, ID, REG_ID, REG_IP, REG_DATE, UPD_ID, UPD_DATE, UPD_IP");
		queryBuffer.append(") VALUES (");
		queryBuffer.append("GOODS_REVIEW_SEQ.NEXTVAL, '"+gno+"', '"+content+"','"+name+"' , '"+pass+"', '"+id+"','"+id+"', '"+client+"', SYSDATE, '"+id+"', SYSDATE,'"+client+"'");
		queryBuffer.append(")");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}